2015-11-06 - 19936 - Spec - Assign materials to vendor capacity #ABAP #ABAPVendorCapacity #PurchaseOrders

SPECIFICATIONS

19936 - Spec - Assign materials to vendor capacity

Purpose

Assign materials to vendor capacity to calculate consumed capacity.

Admin Info

Purpose	Assign materials to vendor capacity
Requested By	Laxman
Spec Created By	Babu Lankipalli
Spec Created Date	11/06/2015
Spec QA by	Laxman
Objects
Document Status	Completed

Estimates

Sl.No	Activity	Estimation in Hours
1	Research	16
2	Documentation	08
3	Development/ Config	40
4	Unit test in DEV	16
5	Unit test in QUA	16
6	Other activity
	TOTAL	96

References

Prior Tickets

[Provide links of prior associated Spec / Break Fix BOSS document(s)]

Documents

[Attach any document(s) received for the requirement(s)]

Spec Changes

[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]

Sl.	Change Details	Requested By	Requested On	Notes if any
01	Assign materials to vendor capacity after creation of info-record and need to run as batch job daily	Babu Lankipalli	11/17/2015
02	Assign materials to vendor capacity through LSMW immediately after creation of material and info-record	Babu Lankipalli	11/24/2015
03	Assign materials to vendor capacity using user exit of info-record	Babu Lankipalli	12/11/2015

Functional Requirement

Purpose/WHY:

[Explain the purpose of the project and the reason why this requirement has come]

To calculate the consumed capacity by running the vendor capacity situation report need to assign the corresponding materials to Vendor capacity.

In Scope:

[List the activities to be included in scope]

Out of Scope:

[Out of scope activities]

Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]

By running the vendor capacity situation report, we can find the consumed capacity of vendor. But for this as a master data setup we need to assign the materials to vendor capacity. To optimize the assignment of materials to vendor decided as assign the materials from the purchase orders created on that particular day. This assignment program will run as batch job daily.

Will Develop a program which collects the materials from the PO's of the particular day and assigns to vendor capacity planning by creating records in table 'J_3ASUCAL'.

Logic to assign the materials to vendor capacity.
- Get the list of POs from EKKO by vendor based on date range
- Get the list of materials by inputting above POs in EKPO
- Assign the materials to table J_3ASUCAL and field MATNR

This will help vendor capacity situation report to get the following details:

Total capacity (J_3ATOTCAP)
Consumed total capacity (J_3ACONCAP)
Total overload capacity (J_3AOVECAP)
Consumed overload capacity (J_3AOVECON)

Few of the Important fields in table 'J_3ASUCAL':

Material - MATNR
Vendor - LIFNR
Purchase Org - EKORG

New approach to assign the materials to vendor capacity (As per change request received from Babu on 11/17/2015).

Program will contain two option to run the program.

For background – Consider the previous day entries from EINA table and based on the vendor material combination assign the materials to vendor for vendor capacity planning.
Foreground – User will give the input data such as vendor and material. Based on this program should assign the materials to vendor for vendor capacity planning.

Logic to assign the materials to vendor capacity.

Selection for background will be info-record creation date.
Selection for foreground will be vendor and material.

- Get the list materials and corresponding vendor from EINA table.
- Then from MARA get the silhouette (prod hierarchy) of that material.
- Based on silhouette assign the materials to table J_3ASUCAL and field MATNR based on vendor.

New approach to assign the materials to vendor capacity (As per change request received from Babu on 12/11/2015).

Assigning the materials immediately after creation of Info-record using user exit. This user exit will be triggered immediately after saving of info-record and assign the materials to vendor based on the silhouette.

Test Plan

[List test scenarios/cases to be executed here]

Test ID	Test Scenario	Expected Results
MM001	Create material and info-record using material creation program.	Material in the info-record should assigned to vendor capacity.
MM002	Create material and info-record by ME11 transaction.	Material in the info-record should assigned to vendor capacity.
MM003	Create material and purchase order without info-record.	Info-record will be created and material should assigned to vendor capacity.
MM004	Create material and info-record. Then execute the program in foreground by inputting the file, which contains material and vendor.	Material should assigned to vendor capacity.
MM005	By inputting the material and vendor run the program in foreground without info-record	Should get the error log as 'Maintain info-record'
MM006	Create material and info-record. Then execute the program in background by inputting the file, which contains material and vendor.	Material should assigned to vendor capacity.

Solution Details

[Provide complete technical details for configuration or programming here]

As advised above created a new program ZMM_VCP_ASSIGN and enhancement the info-record using user exit to assign the materials to Vendor capacity.

Issues

[List Issues / Bugs in configuration or development]